SELECT *, CASE WHEN `name` LIKE "spring valley%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spring valley" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spring valley" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "spring valley" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("spring valley") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$2,000,00040 Noyes AveSpring Valley NY 10977View Listing
$1,900,00033 Midway RdSpring Valley NY 10977View Listing
$1,500,0001 Charlotte DrSpring Valley NY 10977View Listing
$1,300,0007 Bruck CtSpring Valley NY 10977View Listing
$1,299,999206 Union RdSpring Valley NY 10977View Listing
$1,299,0005 Salem CtSpring Valley NY 10977View Listing
$1,275,00022 Appledale LnSpring Valley NY 10977View Listing
$1,200,000139 Union RdSpring Valley NY 10977View Listing
$1,200,0001 Kim LnSpring Valley NY 10977View Listing
$1,125,000489 Viola RdSpring Valley NY 10977View Listing
$990,0005 Charlotte PlSpring Valley NY 10977View Listing
$924,999198 Summit Park RdSpring Valley NY 10977View Listing
$899,000116 McNamara RdSpring Valley NY 10977View Listing
$899,00017 Jay StSpring Valley NY 10977View Listing
$899,00015 E Nicole WaySpring Valley NY 10977View Listing
$885,00024 Locust StSpring Valley NY 10977View Listing
$855,0002 Trinity PlSpring Valley NY 10977View Listing
$849,9992 Rensselaer DrSpring Valley NY 10977View Listing
$799,00020 Wolfe DrSpring Valley NY 10977View Listing
$789,00082 Hempstead RdSpring Valley NY 10977View Listing
$759,000277 Hempstead RdSpring Valley NY 10977View Listing
$749,9991 Hazel CtSpring Valley NY 10977View Listing
$739,000647 New Hempstead RdSpring Valley NY 10977View Listing
$720,0009 Ann StSpring Valley NY 10977View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 4:38:12 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah